SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001419s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017471 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017471 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376248,552327,999557,30505,24873,201748,645415,364728,883224,621847,384066,31461,113189,72938,824037,587629,552474,837578,167631,516646,490018,710337,836339,602673,508939,869709,937301,875854,862655,588592,629425,293449,712951,262426,1044927,683287,419220,720813,651021,423280,154497,518889,202890,186541,978708,46247,801873,134630,717180,534835,878933,912215,221478,930433,707806,1037213,587320,109927,603569,34675) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]