SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 251040 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 251040 [ RunTime:0.001464s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (397039,516500,149716,748894,921047,673699,671011,979888,470046,338717,67366,807073,395704,486608,889784,274545,294045,72646,357467,683927,880704,637176,54998,195167,202607,534979,351354,542720,798679,1047419,448299,600064,947578,945588,99146,506011,427558,621605,541569,863738,725089,508233,450073,826241,529134,898017,855204,653369,739818,731598,975175,329762,241027,133992,1009501,98584,101334,953216,325360,802355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 251040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 251040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001037s ]