SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 701018 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 701018 [ RunTime:0.004272s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267825,733214,132303,406300,469780,770831,87266,709865,568320,723488,747752,14025,406518,506125,121204,720068,631841,9780,877952,795133,271690,950863,612501,21368,820601,406953,955494,172782,645026,227926,474679,55845,326707,912667,433011,751421,418490,765974,591116,78619,168234,86720,974556,517498,1017949,768667,891230,275135,99501,811620,815085,712480,532686,584402,1025646,874499,456173,21161,409958,40532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 701018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 701018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]