SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193113 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193113 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405387,360232,37521,730951,729350,575562,25323,712585,85381,863073,696112,1037479,55367,849169,897377,1016735,507586,496030,474414,783868,232041,21669,559672,603890,46664,700785,201683,748437,838036,50690,22985,210336,163494,386848,550078,414008,651492,736841,3666,474560,67355,270341,508616,919012,439813,994324,656773,24489,826204,658999,436767,984602,487427,206114,897584,279863,363684,144743,340537,518421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]