SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002011s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540651 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540651 [ RunTime:0.005554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612309,75789,765774,1025757,27280,808834,907484,529447,318033,366820,867463,744424,694203,874941,22027,698047,196208,832006,1031713,68227,158775,657932,651484,822850,662849,751629,225933,566641,678170,6187,1047875,650416,34231,1020250,314946,597882,586714,219180,67161,858798,395825,159660,596476,596512,469825,788531,535664,876316,151375,879383,1022169,977570,72678,250100,240360,302584,226872,785394,534166,767977) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001090s ]