SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583441 LIMIT 1 [ RunTime:0.001513s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583441 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112202,1012160,184786,22325,934695,840781,735010,132192,897509,619579,604421,714312,909772,769745,517642,830776,272164,788231,596927,739344,826721,10558,961524,483637,984863,709290,993533,727401,855085,315496,275064,550184,426759,748420,732112,443708,456923,709956,486215,466156,348313,410564,558012,328155,690600,485142,145930,664945,522434,347665,69523,298989,980819,122058,476838,544876,736082,688521,3514,634661) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001205s ]