SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520245 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520245 [ RunTime:0.001964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909660,500872,896068,828950,245122,511568,330886,371577,233258,942884,149630,271634,342275,4089,983604,546659,4276,314236,723962,448539,293601,691923,736050,1004584,204878,242513,184650,461405,680582,918882,1030014,955392,575575,1036787,855353,167109,675538,433058,260541,526428,600794,101678,842711,317573,285318,544731,330569,66566,822692,665711,618306,577634,189112,482464,471159,778927,587330,799525,1017060,1041522) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520245 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520245 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]