SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398841 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398841 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (905278,512383,315825,79193,853075,644114,654092,871344,292370,509720,19116,594914,655840,449888,487133,429897,4152,931246,1035206,521520,715929,797537,790163,542818,180436,807210,205408,978966,708007,934420,313288,767459,963306,945091,358617,650398,61033,709080,987737,569591,620419,788684,102170,358513,668904,889644,111898,1001828,388,195538,43934,237628,48361,831860,279236,102547,126978,273860,5684,295301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]