SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102056 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102056 [ RunTime:0.001828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (849265,661365,797844,550013,875420,430010,425054,802965,10533,395150,961169,191448,511237,916985,75462,487991,412076,151743,128203,579111,545381,402577,817298,107494,278988,34184,706921,139830,711112,276480,973938,356930,441217,568677,595858,242240,542542,266738,988576,867214,301327,29234,52900,315544,483997,666070,943934,565400,270885,915280,182572,1003053,858482,39239,88421,387319,630099,935217,718653,828846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]