SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334688 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334688 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475878,668607,607678,939032,221440,993715,913481,924251,333939,358690,343605,25156,923507,803042,414747,93887,1046174,742135,217627,15530,334732,449494,168569,615242,790333,758362,934547,119244,30585,9744,248836,777766,310926,641913,313758,101201,635099,648878,221914,820987,867827,369134,394321,661698,138728,590801,686619,742392,377650,980714,1028478,390893,448442,31534,19153,806052,826506,723353,5951,948023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]