SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001543s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559596 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559596 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698234,83701,702472,892067,178935,409829,560033,547966,277594,361515,374092,76604,143282,386711,48656,839573,768578,128393,769048,162228,338039,705252,742740,315828,48031,909770,166552,786420,77627,193449,230873,901040,399699,289706,671070,861245,909531,114905,344016,821029,130077,439952,663481,320792,296054,138100,817172,145006,951342,309915,916648,636545,441832,577045,349932,862313,231016,768417,660846,423993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001094s ]