SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470915 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470915 [ RunTime:0.002246s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (658892,1000737,347791,275335,519714,1004061,583304,423109,475681,175000,163443,473979,489131,409576,653698,42968,44037,889888,855941,1034925,150613,147794,350717,408383,449056,995338,539705,31529,883032,218220,616239,968176,164633,574636,411366,837882,672935,725334,104490,493382,455799,760890,290479,1018973,456852,694243,128010,679813,905086,643211,350707,486368,237754,315665,735012,238901,656356,515377,522018,670083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470915 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470915 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]