SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014618 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014618 [ RunTime:0.003292s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (669896,311701,801737,241384,329847,3911,989334,379627,31353,241271,536632,920534,481411,861274,36860,786175,572229,343381,249876,59525,79408,71870,602415,685584,858140,276166,73230,987375,405865,785021,333906,283994,582175,589629,388047,87494,383239,257549,46375,228141,109471,272342,405642,738765,854562,580563,504045,1002451,776665,719085,416544,375963,807977,766676,902717,177539,707544,4928,379494,869260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]