SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201427 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201427 [ RunTime:0.002877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (606710,160571,541974,634415,1042616,761831,279776,372078,647019,292623,115567,966941,800307,893470,276199,516168,488450,112345,482188,647472,964581,502378,339936,220710,228407,850016,720487,141550,544756,269347,555017,379015,1043838,971803,56229,388794,424394,575388,74243,670661,562636,369810,78718,80350,747626,450791,563592,512322,68101,946196,766483,1039221,40816,673499,108199,970079,603235,941079,835764,496679) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201427 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201427 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001954s ]