SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000938s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50404 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50404 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (918878,878171,789717,110033,228752,74634,3335,690076,393883,954719,963347,167798,937711,867308,1038078,886123,996619,680345,500796,541030,355430,280918,864118,723666,191679,320537,1036386,611898,731586,21564,539409,621712,84417,10175,883393,705234,534627,334065,572912,657617,925583,312305,624193,835510,183933,205125,26544,20678,612078,332544,326237,700132,208517,662624,567528,464028,889586,274388,442937,76571) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002050s ]