SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107498 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107498 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473737,1037423,356126,116022,49369,454021,584659,116467,991318,383742,243193,480173,557370,615055,604455,989999,795402,387118,910035,139685,383446,283223,282223,778759,636233,266632,20378,92049,256815,882557,810692,527037,1021796,799173,52091,589055,938488,140457,319939,836874,1511,616440,380270,475228,310845,459558,63130,997123,181107,936894,27710,987951,73095,185475,538290,913158,631493,1005183,68640,768306) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000647s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]