SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5101 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5101 [ RunTime:0.002651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (730038,43079,588799,172075,1023406,666685,797321,788270,620897,102339,752242,11599,1044076,846873,406151,470755,999599,151679,738123,716581,181563,502616,531086,847714,498237,260496,220061,179562,780860,412835,47399,614364,343171,545621,684252,21538,924710,473801,1044869,196376,390623,1027157,40366,133429,937100,79615,672383,145107,76623,221174,510130,893230,405837,1017659,126373,685647,586202,715217,260836,913693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]