SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003393s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504440 LIMIT 1 [ RunTime:0.000944s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504440 [ RunTime:0.002885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269888,90531,664916,149732,485612,221127,769698,968388,566699,585108,726184,740990,669238,218949,123028,28426,402145,536176,904678,42479,1045897,702413,913957,636529,936982,822010,761322,171497,604779,362455,758870,141560,555328,972180,48218,324903,881911,280099,775776,34888,961244,548197,1026876,1024997,372786,385796,606729,728310,464426,789920,90591,124902,595578,1030577,810909,625371,724232,846115,529341,49572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]