SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428071 LIMIT 1 [ RunTime:0.001811s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428071 [ RunTime:0.001986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (794427,384014,682140,121387,540633,418917,227804,722827,334938,779459,440199,282672,518038,583755,970470,979118,916852,98450,657511,161502,38298,249299,258565,469145,136011,299765,610917,224668,771173,1036035,1023035,573418,310979,268563,904787,241539,587187,237049,741380,679367,678388,118818,994459,287429,495418,98819,1043304,36308,738917,988036,470518,98874,807984,548535,819725,422855,706592,931725,232022,63019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000607s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]