SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400148 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400148 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (387002,750840,969802,397025,152831,370351,1026338,503651,859821,264688,832843,449267,920320,831248,1006918,465986,751117,984002,619591,206639,376630,104290,861439,174671,519808,787303,422952,455487,139150,764177,24337,817997,607286,246998,188987,798872,682307,1015917,934624,679344,427920,417872,997581,77722,1033092,404947,297725,965843,1009735,389766,396648,84953,538213,925750,292043,827696,357020,306889,859442,968387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000362s ]