SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505938 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505938 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497697,71763,893868,869520,735157,755535,372951,951054,74693,232083,940904,189847,471980,23926,534447,895994,187116,27837,808476,20301,348580,801968,222832,124658,328322,83061,505318,801549,158973,731282,260571,546017,355723,936088,444713,406481,718119,537228,218037,1017629,408480,523871,835614,96164,977267,486130,954541,306248,967504,766190,439815,487619,28663,787415,881925,784467,305940,631442,381254,242211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]