SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003102 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003102 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728493,534923,917378,856,160526,1025174,862569,548633,972190,274968,861204,958500,550281,696127,907631,20681,126521,1006389,467851,667459,523227,536258,527613,868936,149128,303360,838127,520318,745259,867043,536640,342364,180002,535669,1030149,724197,721277,113400,832296,90800,212862,923659,657764,851781,634885,559930,68486,904555,82222,1005308,342765,58571,644152,29339,96373,35417,740749,905250,912066,994752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]