SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380607 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380607 [ RunTime:0.001516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (998875,155601,821007,636865,326541,943653,579824,113849,201097,394267,493756,1019598,139135,655070,245313,701054,598907,694999,193851,511740,118032,381807,363564,277580,8790,958778,787052,441226,287842,1008828,280970,755552,376925,1001328,742471,488028,126969,431840,463047,191908,398478,334376,687879,807873,55066,87403,634431,525198,113218,100768,449171,707657,902634,724770,670209,817927,701667,1021030,176553,179159) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380607 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380607 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]