SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106241 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106241 [ RunTime:0.001892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (868497,267994,67067,376288,277118,921671,757760,439625,654979,888081,1036951,125701,479891,852027,772077,914322,356281,763737,101749,323889,730112,332988,178534,810500,906691,747865,221153,721948,636613,662762,739431,954829,624184,1007449,653145,272975,535047,955899,17238,810578,382287,137583,580136,361763,1016246,434896,215306,284635,396334,582766,263647,887041,216862,902257,641892,761017,803933,293405,310257,611197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000767s ]