SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401386 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401386 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (176421,521821,727299,849505,26410,591910,100150,840145,571865,409772,785479,14834,758554,999356,900542,1044714,29531,197364,77842,181001,217216,251772,123822,880959,809730,61913,721851,37346,471444,537745,60633,29899,181619,85980,43079,557270,580021,32286,996150,243538,228174,1012793,452016,390932,188490,483848,20869,226400,66245,799336,565498,934340,31234,29795,604976,385337,605952,819352,368858,239478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401386 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401386 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]