SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51850 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51850 [ RunTime:0.003169s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (448054,396889,887425,806407,611885,389131,481400,1039871,245594,597816,849210,364329,700422,801552,1005322,827732,842191,308176,900892,448030,964032,737834,463534,108500,904559,608646,51729,332605,1014586,357239,864612,770696,379237,116932,510614,409239,116331,653472,524699,580463,684666,367961,958353,601796,71584,1009662,220996,158666,219872,244089,123785,945111,491464,857817,238018,572178,48540,585487,41651,385448) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]