SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027920 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027920 [ RunTime:0.001429s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269461,513915,730255,765866,905713,4922,958660,125180,167227,879233,765447,297839,241069,604093,218821,114323,785426,350046,258634,426747,990864,897967,971394,218413,70424,925220,545490,291069,199482,270506,64638,692290,906200,690360,551894,386458,717553,180032,428453,642075,627465,511785,769742,992980,666489,792336,982465,1028314,466299,334824,891805,879517,446334,726021,204246,854237,517407,26308,238233,901298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]