SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311728 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311728 [ RunTime:0.004312s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398914,195895,751835,866063,779748,903213,736269,438779,1040851,991947,450461,606517,225165,93301,443531,123493,976138,313879,390421,1010703,342246,961198,1024323,198262,9163,253456,300105,888341,957788,522083,471910,846711,172177,376535,615110,401351,571222,312088,1027522,742767,219412,579312,643247,653932,1046559,651839,459213,648787,934955,34937,428579,116622,457500,48078,68458,725458,351680,359000,154098,51641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002626s ]