SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036974 LIMIT 1 [ RunTime:0.000472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036974 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160458,635352,182132,511660,201559,190876,630069,573493,567434,24490,818224,138755,462704,62905,219919,155826,987037,26557,428210,517822,827767,611784,222126,1030064,668569,383822,134833,577841,576800,541262,1002398,342620,499902,706163,942614,281935,417744,1024960,792439,620176,73201,247656,363835,651021,188721,503469,324128,94260,1012512,49546,515943,924533,125155,25458,175414,543497,988144,967841,417011,974458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000912s ]