SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426512 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426512 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (227501,565541,411176,605363,65267,758558,309678,999156,732409,508634,727169,586691,678064,322663,296218,730539,1013679,1045781,890348,935184,931982,994343,239785,940423,139536,21578,552384,239601,912198,615667,221195,995112,74113,115527,546347,958993,858468,134631,60099,665443,381558,850653,231599,349908,425940,181789,332961,961845,1035283,220950,1011409,315153,675172,676671,354143,482545,391258,312507,630021,365703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]