SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001919s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195040 LIMIT 1 [ RunTime:0.000568s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195040 [ RunTime:0.003738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (552451,1007999,691949,1044282,21240,276525,572083,939118,957882,757038,139164,21393,262829,30675,366520,188955,764752,29256,402836,109196,967698,379777,504725,766433,199966,472652,663437,538150,493596,602153,1028782,998571,379134,452996,829844,684180,921994,228070,290850,281316,482006,1003644,576313,1037544,623347,520715,396334,683444,394684,594512,1012983,838646,748932,793904,563964,352952,99859,734530,996258,938969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005820s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]