SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001457s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 364761 LIMIT 1 [ RunTime:0.000283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 364761 [ RunTime:0.002857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540401,623504,157913,672282,204173,159401,43425,230483,12746,358623,293310,963292,1027540,999078,71435,828529,517617,896917,495172,269758,792109,949451,409119,171989,177818,668745,189886,469840,73851,445529,54150,977893,580764,925919,704180,340969,346274,551247,1032068,719046,373226,179032,442492,881784,145122,361308,997158,446273,966466,866519,871298,835974,822457,50451,822499,331793,183757,900487,376877,544332) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 364761 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 364761 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]