SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001556s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007207 LIMIT 1 [ RunTime:0.003818s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007207 [ RunTime:0.003226s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (45983,554927,211854,661052,251115,60240,464311,686742,47323,890321,2592,507403,1031781,170875,865318,241025,567534,1033104,972252,326967,856472,420160,945436,354777,824401,840359,591322,491978,209516,283620,74528,535259,465869,911270,501582,402650,208986,257186,493465,981673,586709,685969,755244,662935,746463,708595,707771,600759,504235,484182,689624,717170,487025,122615,1005994,277970,509038,26471,574170,776981) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]