SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413186 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413186 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (969751,231892,204046,834408,312684,225546,785112,995069,35193,289228,467906,725079,749600,871229,158332,296325,752898,660280,526538,620623,411490,243193,232151,727289,101906,575044,983817,427750,353411,127255,994007,754134,971476,244451,628341,455242,168880,166159,546980,565404,171805,365994,901592,268674,1006640,911230,888145,335880,473018,72532,1048719,596748,775310,184548,491302,74544,580858,16753,235111,209614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413186 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413186 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]