SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001832s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522856 LIMIT 1 [ RunTime:0.001034s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522856 [ RunTime:0.004595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (279681,290637,536200,499364,716820,1038222,89106,576949,9449,838537,640185,1024369,475778,642980,434970,81938,435371,539038,230882,869944,174442,292034,200906,171104,258806,872712,1030372,826741,650929,811363,862923,114476,543330,203953,900282,389613,1021432,733931,249247,836562,454668,1037699,307344,576805,618744,573814,84947,803363,925219,55789,983718,666091,174503,381957,711822,124709,3841,346342,820069,76351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000930s ]