SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 114012 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 114012 [ RunTime:0.001528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202425,817391,175685,260561,132359,351600,556284,5057,200825,197441,966671,31242,634210,216502,681668,375232,759157,156873,952074,557546,537343,1019334,400659,1041860,104960,863475,155358,892389,307694,420716,560128,924436,258255,643224,45059,917674,756498,730477,996113,196540,760540,480834,155445,111321,316317,685364,802420,960192,121051,165553,900110,664426,246434,370816,348548,984635,409077,924031,196386,191965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 114012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 114012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]