SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044993 LIMIT 1 [ RunTime:0.002102s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044993 [ RunTime:0.002895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382947,864673,153751,588677,472949,385798,677024,994812,664441,780932,437259,752133,332535,1035044,64431,653703,948925,904928,836595,159976,334858,66757,451249,591370,686676,30004,551459,342733,479269,101330,681615,364980,666562,1043405,984938,655140,458961,763083,878972,969803,336873,835449,312766,481041,886006,799493,888204,359339,146896,346961,687920,5980,89127,304669,163529,437835,811867,547382,368404,999360) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.024191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002303s ]