SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110153 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110153 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39120,186773,547208,640670,879490,405560,425917,791405,216318,756203,1034595,393034,575910,109606,783078,289845,618109,806689,780604,400243,571084,185588,90937,129364,718052,930735,486611,312232,286259,378890,534774,1038493,452762,276974,552938,394601,632284,619998,630031,637449,292700,1017576,1030588,430941,518174,254069,653663,549449,139668,229267,577497,602888,411899,67247,159780,642174,132121,29747,670455,415254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110153 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110153 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000769s ]