SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41059 LIMIT 1 [ RunTime:0.001416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41059 [ RunTime:0.004482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014680,296352,18102,1024747,804712,155627,537705,368040,862328,944948,259383,485208,700982,194153,976442,369861,1005014,622963,431105,177326,978308,960500,831264,575627,437948,997745,644514,639452,682546,751936,848365,992559,280792,804660,786123,289900,106716,1031884,902010,1042668,842661,305841,707745,608520,660965,313987,11528,559988,473181,771493,739750,833162,395490,584607,758996,454072,118942,249814,364367,83443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41059 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41059 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000383s ]