SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403529 LIMIT 1 [ RunTime:0.001401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403529 [ RunTime:0.002582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044331,767413,957851,213903,244950,88880,288070,910162,522422,117042,191013,954971,181993,1020594,1032055,917428,116054,14231,97052,19600,876519,620362,927997,950469,875145,960154,428191,237754,1127,412469,369801,837188,688385,134536,551895,1038826,316099,696735,146659,482166,465590,731730,194066,506736,937384,506968,1048873,1020664,958276,351271,896171,442630,389456,434778,486958,769444,738010,397974,912893,705624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001863s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002721s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]