SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000887s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 72188 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 72188 [ RunTime:0.002490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408875,341512,33396,706099,1042982,252780,116527,177765,189316,160500,83586,424837,314528,116916,139444,311277,278089,1016554,757604,943592,362460,111586,798137,844649,1009470,824750,541348,178636,142696,616374,443747,921570,230273,874471,508286,967438,195127,972804,790570,982861,828837,953425,336054,884088,999419,519649,826984,909033,741243,761189,233628,220563,39426,616592,5983,868065,1039233,413940,216795,480954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 72188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 72188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]