SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415670 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415670 [ RunTime:0.001509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507773,356977,402526,448302,592799,734407,407436,449419,999801,452144,163134,887547,795391,7168,557963,329189,602112,949706,282318,562595,483898,374529,486497,227560,712899,671709,1045458,565635,115865,98217,850432,843559,735568,967047,73577,747230,103,956516,17790,343545,824043,987070,839925,145485,111117,60619,774959,209352,738621,628135,937670,275018,934900,644010,83542,181732,714343,552215,609582,886627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]