SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541326 LIMIT 1 [ RunTime:0.000500s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541326 [ RunTime:0.001409s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (607300,852404,46002,306336,245926,169534,394872,24147,133138,267642,302034,1017795,851978,80122,306875,630617,1043488,772845,949961,814178,689040,74076,867278,58450,114389,4008,923839,797388,806579,798599,867510,178577,68841,296967,267378,351080,756230,605730,473013,515570,193679,498141,605046,176138,595604,310117,190018,103209,418985,965818,703329,802976,580851,62465,811681,778315,233221,298831,931787,464698) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541326 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541326 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001262s ]