SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481014 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481014 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (95857,63364,589413,265388,338827,914927,18550,201256,671883,684447,546658,445826,133506,796582,576857,423129,729090,138750,657580,933132,792744,385093,521709,458447,550265,418648,293805,119306,788254,968812,282517,861248,603361,525620,195989,342972,857010,807776,207229,103687,251134,159597,430661,780714,475830,59433,461258,186513,189566,307263,807910,625381,199815,474814,144823,975208,281464,1006140,462975,823876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]