SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102748 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102748 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28884,480769,840489,322922,301467,110934,598922,723214,533089,155031,900102,745088,312042,858299,840216,167294,490635,538907,140895,974362,942734,290298,679323,949900,797893,1043581,371025,671258,682514,659974,407626,366125,43394,341499,478387,370293,532894,1043118,465516,237132,828984,290072,72478,572483,1020027,426769,78586,762658,17624,906032,349612,49944,631734,284046,863668,789713,299978,553857,781133,978785) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]