SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002883s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 975343 LIMIT 1 [ RunTime:0.001653s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 975343 [ RunTime:0.003249s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113653,803955,293773,653900,652761,459318,487898,185124,922154,221041,96123,133179,338522,904411,208785,39329,917988,559470,1017235,418237,428053,490696,958728,230587,126869,900315,958660,1048440,848077,609670,52948,895386,571724,374865,835447,221506,104272,710445,934150,536198,949944,938402,1035095,358523,29398,326205,570797,334338,969154,700322,956020,513805,548976,740605,681888,735929,443300,478738,869196,602215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 975343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 975343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]