SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335838 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335838 [ RunTime:0.003885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160803,323660,442848,701899,327648,928512,265942,215551,1009120,422215,355800,34500,1048849,193773,77408,816892,34561,374172,498038,94097,341439,803429,449394,299364,374636,143320,184378,705533,215095,48945,925039,60580,713733,964191,378809,567718,156640,574634,865335,788240,246575,890689,542062,1025923,185508,710776,101169,619497,278011,730874,394526,960605,817677,719068,161352,718657,1001426,594101,184554,538774) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001080s ]