SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550260 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550260 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482606,536347,1015960,528632,277220,776499,418975,636651,12806,976575,117583,292721,650509,520654,146616,906794,554128,895807,54011,191935,108241,81169,267692,518547,297024,456997,168483,979100,411138,214449,248390,103739,443221,709408,511758,489892,78196,615064,462816,420652,801467,246158,83458,763759,161948,460885,825531,414936,829675,380126,395537,773380,216980,267173,728950,133729,382345,628338,572997,750708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550260 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550260 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]