SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507217 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507217 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (167492,91195,66099,243617,295254,117580,39158,793603,433171,109931,181921,585271,588570,617865,512349,63676,229779,786171,787096,94178,634663,875927,1016498,433030,177230,875719,691729,841273,979011,742744,34751,177136,181072,518199,759810,909903,580602,477783,1042263,655947,224110,677675,555608,253200,212859,1005860,562509,904412,691601,77670,89651,419352,614973,318623,4305,203987,270609,604609,170362,89755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001674s ]