SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001683s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 211480 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 211480 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514809,195752,156247,203378,906056,71067,424311,604860,329132,676119,937955,724644,176614,724477,749192,1001362,285453,182224,62729,497435,418110,772066,707323,863223,530573,355165,980420,523594,570143,222418,125419,678979,429126,232569,44913,752111,486487,167209,233865,179628,237631,93783,986369,271452,43202,915239,354411,569854,330061,622091,510428,806612,874482,823816,214400,99857,376080,558953,339375,731216) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 211480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 211480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]