SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40402 LIMIT 1 [ RunTime:0.000580s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40402 [ RunTime:0.002021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (631978,383426,73728,547214,962740,731876,72236,361066,884764,470837,70747,582527,230052,369134,900354,43515,178526,553116,966487,387952,982019,920435,398917,65344,414050,862522,488303,242445,559710,736118,83226,485147,105719,982185,328064,250347,79410,361553,668857,620779,270311,37332,44218,863790,75976,263819,310831,1036464,161017,605209,314546,894442,627608,225388,168855,918203,161230,442503,898709,454089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40402 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40402 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]