SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286180 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286180 [ RunTime:0.002685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309374,471113,584589,824667,408716,380766,454120,511804,557118,628024,582814,655379,677915,605597,178626,888510,113891,229516,346353,832943,109588,498058,968663,232178,445738,390304,333718,945027,915847,877661,340009,1035802,730466,357753,490783,754194,169292,683119,343027,323817,214974,17163,274386,12660,554534,107348,311147,43217,214985,306845,846135,182319,1007105,201486,320136,282726,90231,177868,291323) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003184s ]