SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478404 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478404 [ RunTime:0.001595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104328,826441,1016883,201101,977085,204438,724920,1039341,959041,848725,519219,421785,727687,296659,647941,467761,896506,335409,281473,337557,820927,699701,215069,818213,64237,65034,442381,843673,140837,963905,815113,392872,1029513,512547,124125,183965,789266,1048551,546164,1010201,991448,426642,288567,447092,168486,55338,721493,63525,385657,984671,5375,883239,502379,194240,184273,893671,713372,963809,309881,1010617) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]