SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001480s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449569 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449569 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (887120,530948,38997,454770,965784,202631,251133,57708,571775,871697,323126,341040,867123,906436,813593,663890,704493,356199,201022,773176,689155,723917,234168,967913,1048621,153465,490857,814211,948181,196751,881584,439789,831547,969542,967005,263917,425510,629637,453693,48870,375859,989337,164228,359970,468874,1023595,378423,424404,690454,224033,171555,605778,130782,911138,880503,447941,851491,477389,509924,67306) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449569 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449569 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]