SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 114041 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 114041 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (388302,880648,254256,249370,307068,275860,1012191,395887,711550,804034,926107,427701,763826,785903,979798,262967,886805,471024,112543,817209,904526,719994,610602,625890,644469,336447,479791,944899,33984,291172,672180,267504,274283,173677,641261,140123,823289,798851,977850,532278,1013909,808111,577718,731649,358200,252475,794129,746843,983473,764723,662709,830831,851781,153700,101764,39945,612035,535778,565157,458743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 114041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 114041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]