SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001590s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320086 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320086 [ RunTime:0.003544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (655996,474475,312288,973358,1014203,138584,798268,712813,641437,578782,169601,227552,824520,725742,997836,476576,634750,948487,193664,218038,886572,672433,834018,627926,52642,421187,553861,244302,211429,555957,552529,425025,78268,645097,305725,686114,727958,70529,706693,797877,385412,660737,129494,530035,10400,208214,421974,109764,138760,233599,828437,104534,3429,520053,233587,32573,907808,564973,40767,314225) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320086 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320086 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001118s ]