SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001582s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503566 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503566 [ RunTime:0.002323s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (977623,161778,817159,797275,757996,706893,332012,568106,243213,189309,225598,164232,821945,916031,297463,617948,159240,295299,632742,937787,26151,28645,467112,480193,1032284,461103,850298,262295,703927,247438,255067,504667,638419,689954,240311,477048,944396,128709,510059,761404,254177,252334,643274,504688,910344,124520,452204,396646,838844,617312,523549,1024678,774537,992875,838890,736495,939922,728814,135396,728090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503566 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000708s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503566 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000760s ]