SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507609 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507609 [ RunTime:0.001590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (764319,765784,438965,875551,91755,283493,662938,485251,290959,701399,426100,331282,108170,672832,774005,211467,671841,8948,741713,246918,900647,797940,556691,683762,118194,67836,548297,598779,326897,917243,272898,23236,770014,213938,528601,901221,270551,333227,349309,742885,106525,585804,253600,626636,354781,213056,61463,665132,550564,850878,257354,221213,445795,604426,115467,713927,24035,803780,357563,131498) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507609 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507609 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]