SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003459s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547942 LIMIT 1 [ RunTime:0.000973s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547942 [ RunTime:0.001862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (651686,114279,344709,317154,150916,47591,793628,232645,247789,1026518,223969,770358,924323,430426,653712,966266,773754,506973,271095,761834,552051,162722,551815,367564,1214,743211,837625,534961,1003619,758476,50262,757827,132229,155998,86074,792210,903052,312499,483239,831440,773421,437462,103258,385290,481974,1047169,156159,118765,25517,993558,287479,367496,658269,145338,406271,52294,834051,109802,821536,115425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547942 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547942 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001897s ]