SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154879 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154879 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715286,533974,202323,968805,590754,401348,4147,425451,169123,498905,692835,385355,390106,572628,230712,246168,166386,720091,380880,262179,768334,476118,64460,1004041,766961,913426,349074,716832,761892,530461,430521,963094,712843,347839,127473,49427,798746,38951,983757,148225,216714,842868,172176,380176,229864,960204,517728,469683,688654,669462,800930,997637,123487,201584,166420,917273,978214,296866,765291,19612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154879 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154879 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]