SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50105 LIMIT 1 [ RunTime:0.000478s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50105 [ RunTime:0.001964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733152,333899,321026,946781,136034,104916,62556,311809,537037,809042,437419,98788,702751,47041,654263,223495,511916,335418,754384,111828,989288,137383,481400,4042,742815,494174,755711,809865,904277,441312,586120,95603,857792,40595,426678,965820,190000,133070,436591,72984,1019778,666302,583949,465368,864710,782001,214550,263168,461628,456805,451931,530981,902930,863452,451032,305214,503198,1034954,170330,701053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]