SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580380 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580380 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (21794,920813,242781,645243,262927,107040,431594,261123,439801,951849,722560,195595,649283,30541,864843,413149,546644,768382,348514,167375,53443,983372,953883,918292,287116,984840,178038,408834,649422,640182,774067,8186,245842,68672,782077,332239,880041,297371,833238,719717,312396,832319,868862,7588,109345,432956,343854,434388,122228,734607,971140,709761,351550,1007380,656742,451103,692502,270432,1013433,1032721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]