SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381307 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381307 [ RunTime:0.002020s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719120,633565,563969,463368,185923,477923,339427,1010923,802868,146573,222287,691590,118661,725763,238044,537505,169680,140502,415514,705183,234287,635279,54263,419125,291934,119953,1029896,7424,234441,861098,515864,586467,329433,936918,38287,962423,230142,527694,790092,93314,482131,275841,642615,653809,857215,624309,74106,772039,892902,398100,978055,440652,2782,457464,363416,584377,212987,519115,928503,632739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]