SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451217 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451217 [ RunTime:0.001716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (732198,1020982,231560,610036,922437,449175,434787,275110,807695,774756,288259,302685,408474,438086,11542,347978,277473,438751,45270,822949,474333,48800,941776,298043,596487,820496,129040,58887,199353,44726,434666,377082,133827,69988,1794,512930,999767,247021,943232,179515,568873,727601,883239,337582,968172,493122,437556,969217,217970,309896,1042915,692882,873102,951860,446756,142183,495112,163219,701021,201492) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]