SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 298043 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 298043 [ RunTime:0.002239s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816814,72951,440347,540915,274251,343366,366613,274932,469617,821623,521339,519034,405646,601185,455741,95953,112504,10191,780376,745318,1009057,959453,543493,1041778,725373,935192,491454,103466,310430,76244,555554,329962,723884,682060,349169,452286,429447,554844,271989,4210,741257,240635,227981,924843,489228,805004,959132,610227,373928,388959,414439,375804,68436,425856,964004,61475,657232,701671,663428,1033048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 298043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 298043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]