SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420830 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420830 [ RunTime:0.001539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342567,404274,113629,720911,181774,941069,954908,770449,14113,687150,875681,867207,1010079,125045,805029,297842,250881,171116,670065,1024439,178465,747724,798738,999721,437307,164554,891663,790184,326526,100156,712405,803037,234852,848339,742966,356887,697087,854252,231374,221379,742889,617320,25710,333233,42294,221215,362405,753241,61396,822227,940547,755054,396729,949162,995309,895598,681452,971884,889030,775220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]